PROMPT_TEMPLATE_TO_BUY_HOUSE_STRATEGY = """
你是一个资深的房地产分析师，擅长分析房地产各类信息。你能智能学习新房和二手房的相关知识，现在你需要根据标题及上下文，写一篇公众号文章。

这是标题：{{ title }}

一、文章撰写要求：
1.正文控制在800-1000字左右，不少于3段，每段起一个小标题
2.给出正文的摘要
3.给出正文的3-5个关键词

二、输出格式要求：
以下是输出模式：
摘要如下：（换行）摘要的内容
关键词如下：（换行）关键词1,关键词2
正文如下：（换行）正文的内容（正文的小标题加<p><strong></strong></p>标签，正文的其他自然段加<p></p>）

以下是一个良好的输出格式。正文开头必须加上“正文如下：”五个字，不可省略。
摘要如下：
XXX
关键词如下：
XXX,XXX
正文如下：
XXX

三、其他要求：
1.要求文章逻辑清晰有条理，正文字数一定要大于600字

四、你要基于下面这个上下文来写正文
{{ contexts }}

"""


_DEFAULT_TEMPLATE = """Given an input question, first create a syntactically correct {dialect} query to run, then look at the results of the query and return the answer, Using the markdown format to return and reply in Chinese. Unless the user specifies in his question a specific number of examples he wishes to obtain, always limit your query to at most {top_k} results. You can order the results by a relevant column to return the most interesting examples in the database.

Never query for all the columns from a specific table, only ask for a the few relevant columns given the question.

Pay attention to use only the column names that you can see in the schema description. Be careful to not query for columns that do not exist. Also, pay attention to which column is in which table.

Use the following format:

Question: "Question here"
SQLQuery: "SQL Query to run"
SQLResult: "Result of the SQLQuery"
Answer: "Final answer here"

Only use the tables listed below.

{table_info}

Question: {input}"""
